Hệ thống quản lý phương tiện trực tuyến bằng PHP

7.323 lượt xem;

viewvehicleservicerequest.php
project /

1 <?php
2 include("header.php");
3 include("sidebar.php");
4 include("dbconnection.php");
5 $result= mysql_query("select * from service where custid='$_SESSION[custid]' AND status='Pending'");
6 $result1= mysql_query("select * from service where custid='$_SESSION[custid]' AND status='Completed'");
7
8 ?>
9
10
11         <div id="main">
12
13             <a name="TemplateInfo"></a>
14             <h1>View Vehicle Service</h1>
15             <h3>
16              Pending Request:
17            </h3>
18
19         <form id="form1" name="form1" method="post" action="">
20           <table width="686" border="1">
21             <tr>
22              <th width="169" scope="col">Vehicle info</th>
23               <th scope="col">Date</th>
24               <th scope="col">Address</th>
25               <th scope="col">City</th>
26               <th scope="col">Status</th>
27             </tr>
28           <?php
29           while($arrrec= mysql_fetch_array($result))
30           {
31            echo" <tr>
32               <td> 
33               Vehicle name: $arrrec[vehiclename]<br>
34                 Vehicle No. $arrrec[vehicleno]</td>
35               <td>  $arrrec[date]</td>
36               <td>  $arrrec[address]</td>
37               <td>  $arrrec[city]</td>
38               <td>  $arrrec[status]</td>
39             </tr>";
40           }
41           ?>
42           </table>
43           <br /><br>
44            <h3>
45              Completed Request:
46            </h3>
47           <table width="686" border="1">
48             <tr>
49              <th width="169" scope="col">Vehicle info</th>
50               <th width="103" scope="col">Date</th>
51               <th width="134" scope="col">Address</th>
52               <th width="104" scope="col">Status</th>
53               <th width="64" scope="col">Bill</th>
54             </tr>
55           <?php
56           while($arrrec= mysql_fetch_array($result1))
57           {
58            echo" <tr>
59               <td> 
60               Vehicle name: $arrrec[vehiclename]<br>
61                 Vehicle No. $arrrec[vehicleno]</td>
62               <td>  $arrrec[date]</td>
63               <td>  $arrrec[address]
64               <br> 
65             City : $arrrec[city]</td>
66               <td>  $arrrec[status]</td>
67               <td>  <a href='vehicleservicebilling.php?serviceid=$arrrec[serviecid]'>View</a></td>
68             </tr>";
69           }
70           ?>
71           </table>
72         </form>
73             <p> </p>
74 <br />
75
76         </div>
77
78 
79 </div>
80
81 <?php
82 include("footer.php");
83 ?>